Hệ thống quản lý trường đại học bằng PHP
1 <?php
2 require_once('../includes/config.php');
3 if(!$user->is_logged_in()){
4 header('Location: ../login.php');
5 }
6 ?>
7 <!DOCTYPE html>
8 <html>
9 <head>
10 <meta charset="utf-8">
11 <meta name="viewport" content="width=device-width, initial-scale=1">
12 <title>Articles Edit</title>
13
14 <link href="css/bootstrap.min.css" rel="stylesheet">
15 <link href="css/datepicker3.css" rel="stylesheet">
16 <link href="css/bootstrap-table.css" rel="stylesheet">
17 <link href="css/styles.css" rel="stylesheet">
18
19 <!--Icons-->
20 <script src="js/lumino.glyphs.js"></script>
21
22 <!--[if lt IE 9]>
23 <script src="js/html5shiv.js"></script>
24 <script src="js/respond.min.js"></script>
25 <![endif]-->
26
27 </head>
28
29 <body>
30 <?php
31 require_once('includes/common.php');
32 ?>
33
34 <div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main">
35 <div class="row">
36 <ol class="breadcrumb">
37 </ol>
38 </div><!--/.row-->
39 <div class="row">
40 <div class="col-lg-12">
41
42
43 <div class="panel panel-default">
44 <div class="panel-heading">Students List</div>
45 <div class="panel-body">
46 <table data-toggle="table" data-show-refresh="true" data-show-toggle="true" data-show-columns="true" data-search="true" data-select-item-name="toolbar1" data-pagination="true" data-sort-name="name" data-sort-order="desc">
47 <thead>
48 <tr>
49 <th data-sortable="true">ID</th>
50 <th ddata-sortable="true">Title</th>
51 <th ddata-sortable="true">Date</th>
52 <th>edit</th>
53 <th>remove</th>
54 </tr>
55 </thead>
56 <tbody>
57 <?php
58 try {
59 $stmt = $db->query('SELECT * FROM blog_posts ;');
60 while($row = $stmt->fetch()){
61 $postID=$row['postID'];
62 echo "<tr><td>".$postID."</td><td>".$row['postTitle']."</td><td>".$row['postDate'].'</td><td><a href="'.$_SERVER['PHP_SELF'].'?edit='.strval($postID).'""><span class="glyphicon glyphicon-edit"></span></a></td><td><a href="actions/deletearticle.php?postID='.$postID.'""><span class="glyphicon glyphicon-remove" style="color:red"></span></a></td></tr>';
63 }
64 }catch(PDOException $e) {
65 echo $e->getMessage();
66 }
67 ?>
68
69 </tbody>
70 </table>
71 </div>
72 </div>
73
74 <?php if (isset($_GET['edit'])):
75 $stmt = $db->prepare('SELECT * FROM blog_posts WHERE postID=:postID') ;
76 $stmt->execute(array(
77 ':postID' => $_GET['edit']
78 ));
79 $row = $stmt->fetch();
80 $_SESSION['edit'] = $_GET['edit'];
81
82 ?>
83 <div class="panel panel-default">
84 <div class="panel-heading">edit an article</div>
85 <div class="panel-body">
86 <form role="form" action="actions/article.php" method="POST">
87 <div class="form-group">
88 <label>title</label>
89 <input class="form-control" name="title" value= <?php echo '"'.$row['postTitle'].'"'; ?> >
90 </div>
91 <div class="form-group">
92 <label>article description</label>
93 <textarea class="form-control" rows="2" id="comment" name="desc" >
94 <?php echo $row['postDesc']; ?>
95 </textarea>
96 </div>
97 <div class="form-group">
98 <label>Article Content</label>
99 <textarea class="form-control" rows="7" id="comment" name="cont" >
100 <?php echo $row['postCont']; ?>
101 </textarea>
102 </div>
103 <button type="submit" name="edit" class="btn btn-primary">Submit Button</button>
104 <button type="reset" class="btn btn-default">Reset Button</button>
105 </div>
106 </form>
107 </div>
108 </div>
109 <?php else:
110 ?>
111 <div class="panel panel-default">
112 <div class="panel-heading">add an article</div>
113 <div class="panel-body">
114 <form role="form" action="actions/article.php" method="POST">
115 <div class="form-group">
116 <label>title</label>
117 <input class="form-control" name="title" >
118 </div>
119 <div class="form-group">
120 <label>article description</label>
121 <textarea class="form-control" rows="2" id="comment" name="desc" >
122 </textarea>
123 </div>
124 <div class="form-group">
125 <label>Article Content</label>
126 <textarea class="form-control" rows="7" id="comment" name="cont" >
127 </textarea>
128 </div>
129 <button type="submit" name="submit" class="btn btn-primary">Submit Button</button>
130 <button type="reset" class="btn btn-default">Reset Button</button>
131 </div>
132 </form>
133 </div>
134 </div>
135 <?php endif ?>
136
137
138
139
140 </div>
141 </div><!--/.row-->
142 </div><!--/.main-->
143
144 <script src="js/jquery-1.11.1.min.js"></script>
145 <script src="js/bootstrap.min.js"></script>
146 <script src="js/chart.min.js"></script>
147 <script src="js/chart-data.js"></script>
148 <script src="js/easypiechart.js"></script>
149 <script src="js/easypiechart-data.js"></script>
150 <script src="js/bootstrap-datepicker.js"></script>
151 <script src="js/bootstrap-table.js"></script>
152 <script>
153 !function ($) {
154 $(document).on("click","ul.nav li.parent > a > span.icon", function(){
155 $(this).find('em:first').toggleClass("glyphicon-minus");
156 });
157 $(".sidebar span.icon").find('em:first').addClass("glyphicon-plus");
158 }(window.jQuery);
159
160 $(window).on('resize', function () {
161 if ($(window).width() > 768) $('#sidebar-collapse').collapse('show')
162 })
163 $(window).on('resize', function () {
164 if ($(window).width() <= 767) $('#sidebar-collapse').collapse('hide')
165 })
166 </script>
167 </body>
168
169 </html>
